﻿using System.Data;
using System.Xml;

namespace UwaySoft.EsheetServer.DataLayer
{
    public interface ISqlHelper
    {
        string ConnectionString { get; }
        IParameter CreateParameter(string name, object value);
        int ExecuteNonQuery(string commandText, params IParameter[] parameters);
        TScalar ExecuteScalar<TScalar>(string commandText, params IParameter[] parameters);
        IRecordReader ExecuteReader(string commandText, params IParameter[] parameters);
        XmlReader ExecuteXmlReader(string commandText, params IParameter[] parameters);
        DataSet ExecuteDateSet(string commandText, params IParameter[] parameters);
    }
}
